SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwrDepartamentos
AS
SELECT     idDepartamento AS ID, nombre AS Descripcion
FROM         dbo.tb_departamentos
GO
GRANT SELECT ON  [dbo].[vwrDepartamentos] TO [Bibliotecas]
GRANT SELECT ON  [dbo].[vwrDepartamentos] TO [CertificacionesServicios]
GRANT SELECT ON  [dbo].[vwrDepartamentos] TO [Juntas]
GRANT SELECT ON  [dbo].[vwrDepartamentos] TO [public]
GRANT SELECT ON  [dbo].[vwrDepartamentos] TO [SoloVer]
GO
